﻿CREATE TABLE [dbo].[Reservation]
(
	Code nvarchar(10) NOT NULL CONSTRAINT PK_Reservation PRIMARY KEY, 
	ContactName nvarchar(40) NOT NULL,
	ContactSurname nvarchar(40) NOT NULL,
	ContactEmail nvarchar(50) NULL,
	ContactPhone nvarchar(20) NOT NULL,
	ContactAddress nvarchar(200),
	TotalPrice MONEY NOT NULL
)